CREATE TABLE [dbo].[NavigationMain]
(
[NavigationKey] [uniqueidentifier] NOT NULL,
[OrganizationKey] [uniqueidentifier] NOT NULL,
[Marker] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_NavigationMain_Marker] DEFAULT (''),
[PageSet] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_NavigationMain_PageSet] DEFAULT (''),
[URL] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_NavigationMain_URL] DEFAULT (''),
[AccessAreaKey] [uniqueidentifier] NOT NULL,
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_NavigationMain_CreatedOn] DEFAULT (getdate()),
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_NavigationMain_UpdatedOn] DEFAULT (getdate())
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[NavigationMain] ADD CONSTRAINT [PK_NavigationMain] PRIMARY KEY CLUSTERED ([NavigationKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_NavigationMain_AccessAreaKey] ON [dbo].[NavigationMain] ([AccessAreaKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_NavigationMain_CreatedByUserKey] ON [dbo].[NavigationMain] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_NavigationMain_UpdatedByUserKey] ON [dbo].[NavigationMain] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NavigationMain] ADD CONSTRAINT [FK_NavigationMain_AccessArea] FOREIGN KEY ([AccessAreaKey]) REFERENCES [dbo].[AccessArea] ([AccessAreaKey])
GO
ALTER TABLE [dbo].[NavigationMain] ADD CONSTRAINT [FK_NavigationMain_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[NavigationMain] ADD CONSTRAINT [FK_NavigationMain_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO